package cn.com.api.mapper.base;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Options;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import cn.com.api.entity.ApiT_stats;

//DAO
public interface T_statsMapperBase {

	// 根据id查看
	@Select("SELECT * FROM t_stats  WHERE stats_id = #{stats_id}")
	public ApiT_stats findT_statsById(Integer stats_id);

	// 查看数据集
	@Select("SELECT * FROM T_stats")
	public List<ApiT_stats> findT_statss();

	// 添加
	@Insert("INSERT INTO t_stats (shop_id, shipper_id, order_count, orders_money, year, month, week, day, order_ontime_count, order_overtime_count, order_aheadtime_count, is_stat,create_time,balance,sendfee,cash_term_money,on_delivery_money,reserve_money,settle_type,discount,is_recieve_box_money,final_pay_money,sum_lunchbox_price) VALUES (#{shop_id}, #{shipper_id}, #{order_count}, #{orders_money}, #{year}, #{month}, #{week}, #{day}, #{order_ontime_count}, #{order_overtime_count}, #{order_aheadtime_count}, #{is_stat},#{createTime},#{balance},#{sendfee},#{cash_term_money},#{on_delivery_money},#{reserve_money},#{settle_type},#{discount},#{is_recieve_box_money},#{final_pay_money},#{sum_lunchbox_price})")
	@Options(useGeneratedKeys = true, keyProperty = "stats_id")
	public int insertT_stats(ApiT_stats t_stats);

	// 删除
	@Delete("DELETE FROM t_stats  WHERE stats_id = #{stats_id}")
	public int deleteT_stats(Integer stats_id);

	// Foreign keys revelant

	// region Indexs revelant

}
